﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="原料收拨平衡表.aspx.cs" Inherits="syc.Produce.Report.原料收拨平衡表" %>
<%@ Import Namespace="NPOI.HSSF.UserModel" %>
<%@ Import Namespace="NPOI.HPSF" %>
<%@ Import Namespace="System.IO" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Configuration" %>
<html>
<head id="Head1" runat="server">
    <title>原料收拨平衡表</title>
</head>
<body>  
<script runat="server">
    protected void Page_Load(object sender, EventArgs e)
    {

        if (!IsPostBack)
        {
            this.Month0.SelectedIndex = DateTime.Today.Month - 1;
            this.Year0.Text = DateTime.Today.Year.ToString();

        }
        Button_Query_Click(null, null);
    }


    protected void WriteToFile()
    {
        DateTime d;

        d = DateTime.Today;

        Response.ContentType = "application/ms-excel";
        Response.AddHeader("content-disposition", "attachment; filename=\"" + d.ToShortDateString() + ".xls\"");
        hssfworkbook.Write(Response.OutputStream);
    }

    protected void InitializeWorkbook()
    {

        FileStream file = new FileStream(HttpContext.Current.Server.MapPath("/Produce/模板/原料收拨平衡表.xls"), FileMode.Open, FileAccess.Read);

        hssfworkbook = new HSSFWorkbook(file);

        DocumentSummaryInformation dsi = PropertySetFactory.CreateDocumentSummaryInformation();
        dsi.Company = "陕西延长石油材料有限公司";
        hssfworkbook.DocumentSummaryInformation = dsi;

        SummaryInformation si = PropertySetFactory.CreateSummaryInformation();
        si.Subject = "报表";
        si.Title = "原料收拨平衡表";
        hssfworkbook.SummaryInformation = si;
    }
    protected void Button_Save_Click(object sender, EventArgs e)
    {

        InitializeWorkbook();
        HSSFSheet sheet1 = hssfworkbook.GetSheet("原料收拨平衡表");
        Button_Query_Click(null, null);
        sheet1.GetRow(1).GetCell(4).SetCellValue(DateTime.Today.Year + "年" + DateTime.Today.Month + "月");
        //sheet1.GetRow(17).GetCell(4).SetCellValue(DateTime.Today.Year+"年"+DateTime.Today.Month+"月");
        sheet1.GetRow(6).GetCell(2).SetCellValue(油管料期初库存);
        sheet1.GetRow(6).GetCell(3).SetCellValue(油管料本期外购量);
        sheet1.GetRow(6).GetCell(4).SetCellValue(油管料本年外购量);
        sheet1.GetRow(6).GetCell(5).SetCellValue(油管料本期消耗量);
        sheet1.GetRow(6).GetCell(6).SetCellValue(油管料本年消耗量);
        sheet1.GetRow(6).GetCell(7).SetCellValue(油管料本期消耗量);
        sheet1.GetRow(6).GetCell(8).SetCellValue(油管料本年消耗量);
        sheet1.GetRow(6).GetCell(11).SetCellValue(油管料期初库存 + 油管料本期外购量 - 油管料本期消耗量);


        sheet1.GetRow(7).GetCell(2).SetCellValue(套管料期初库存);
        sheet1.GetRow(7).GetCell(3).SetCellValue(套管料本期外购量);
        sheet1.GetRow(7).GetCell(4).SetCellValue(套管料本年外购量);
        sheet1.GetRow(7).GetCell(5).SetCellValue(套管料本期消耗量);
        sheet1.GetRow(7).GetCell(6).SetCellValue(套管料本年消耗量);
        sheet1.GetRow(7).GetCell(7).SetCellValue(套管料本期消耗量);
        sheet1.GetRow(7).GetCell(8).SetCellValue(套管料本年消耗量);
        sheet1.GetRow(7).GetCell(11).SetCellValue(套管料期初库存 + 套管料本期外购量 - 套管料本期消耗量);


        sheet1.GetRow(8).GetCell(2).SetCellValue(油管接篐料期初库存);
        sheet1.GetRow(8).GetCell(3).SetCellValue(油管接篐料本期外购量);
        sheet1.GetRow(8).GetCell(4).SetCellValue(油管接篐料本年外购量);
        sheet1.GetRow(8).GetCell(5).SetCellValue(油管接篐料本期消耗量);
        sheet1.GetRow(8).GetCell(6).SetCellValue(油管接篐料本年消耗量);
        sheet1.GetRow(8).GetCell(7).SetCellValue(油管接篐料本期消耗量);
        sheet1.GetRow(8).GetCell(8).SetCellValue(油管接篐料本年消耗量);
        sheet1.GetRow(8).GetCell(11).SetCellValue(油管接篐料期初库存 + 油管接篐料本期外购量 - 油管接篐料本期消耗量);

        sheet1.GetRow(9).GetCell(2).SetCellValue(套管接篐料期初库存);
        sheet1.GetRow(9).GetCell(3).SetCellValue(套管接篐料本期外购量);
        sheet1.GetRow(9).GetCell(4).SetCellValue(套管接篐料本年外购量);
        sheet1.GetRow(9).GetCell(5).SetCellValue(套管接篐料本期消耗量);
        sheet1.GetRow(9).GetCell(6).SetCellValue(套管接篐料本年消耗量);
        sheet1.GetRow(9).GetCell(7).SetCellValue(套管接篐料本期消耗量);
        sheet1.GetRow(9).GetCell(8).SetCellValue(套管接篐料本年消耗量);
        sheet1.GetRow(9).GetCell(11).SetCellValue(套管接篐料期初库存 + 套管接篐料本期外购量 - 套管接篐料本期消耗量);

        sheet1.GetRow(24).GetCell(9).SetCellValue("报出日期："+DateTime.Today.Year+"-"+DateTime.Today.Month+"-"+DateTime.Today.Day);
        //sheet1.ForceFormulaRecalculation = true;
        WriteToFile();
        Response.End();
    }

    protected void Button_Query_Click(object sender, EventArgs e)
    {
        year = int.Parse(this.Year0.Text);
        SqlConnection Conn = new SqlConnection();
        Conn.ConnectionString = ConfigurationManager.ConnectionStrings["SCMConnectionString1"].ConnectionString;
        try
        {
            Conn.Open();
            SqlCommand Cmd = new SqlCommand();
            Cmd.Connection = Conn;
            //油管料
            string sql = @"            
            select dbo.原料期初库存(@年度,@月份,1) as 期初库存,dbo.原料本期收入(@年度,@月份,1) as 本期收入,dbo.原料本期发出(@年度,@月份,1) as 本期发出,dbo.原料期末库存(@年度,@月份,1) as 期末库存,dbo.原料未入库(@年度,@月份,1) as 未入库,[dbo].[原料本年累计收入](@年度,@月份,1),[dbo].[原料本年累计发出](@年度,@月份,1)";
            sql = sql.Replace("@年度", year.ToString());
            sql = sql.Replace("@月份", this.Month0.Text.ToString());
            Cmd.CommandText = sql;
            SqlDataReader Reader = Cmd.ExecuteReader();
            if (Reader.Read())
            {
                油管料期初库存 = Reader.GetDouble(0);
                油管料本期外购量 = Reader.GetDouble(1);
                油管料本期消耗量 = Reader.GetDouble(2);
                油管料期末库存 = Reader.GetDouble(3);
                油管料本年外购量 = Reader.GetDouble(5);
                油管料本年消耗量 = Reader.GetDouble(6);
            }
            Reader.Close();
            //套管料
            string sql1 = @"            
            select dbo.原料期初库存(@年度,@月份,2) as 期初库存,dbo.原料本期收入(@年度,@月份,2) as 本期收入,dbo.原料本期发出(@年度,@月份,2) as 本期发出,dbo.原料期末库存(@年度,@月份,2) as 期末库存,dbo.原料未入库(@年度,@月份,2) as 未入库,[dbo].[原料本年累计收入](@年度,@月份,2),[dbo].[原料本年累计发出](@年度,@月份,2)";
            sql1 = sql1.Replace("@年度", year.ToString());
            sql1 = sql1.Replace("@月份", this.Month0.Text.ToString());
            Cmd.CommandText = sql1;
            Reader = Cmd.ExecuteReader();
            if (Reader.Read())
            {
                套管料期初库存 = Reader.GetDouble(0);
                套管料本期外购量 = Reader.GetDouble(1);
                套管料本期消耗量 = Reader.GetDouble(2);
                套管料期末库存 = Reader.GetDouble(3);
                套管料本年外购量 = Reader.GetDouble(5);
                套管料本年消耗量 = Reader.GetDouble(6);
            }
            Reader.Close();
            //套管N80料
            string sqlN80 = @"            
            select dbo.原料期初库存(@年度,@月份,102) as 期初库存,dbo.原料本期收入(@年度,@月份,102) as 本期收入,dbo.原料本期发出(@年度,@月份,102) as 本期发出,dbo.原料期末库存(@年度,@月份,102) as 期末库存,dbo.原料未入库(@年度,@月份,102) as 未入库,[dbo].[原料本年累计收入](@年度,@月份,102),[dbo].[原料本年累计发出](@年度,@月份,102)";
            sqlN80 = sqlN80.Replace("@年度", year.ToString());
            sqlN80 = sqlN80.Replace("@月份", this.Month0.Text.ToString());
            Cmd.CommandText = sqlN80;
            Reader = Cmd.ExecuteReader();
            if (Reader.Read())
            {
                套管N80料期初库存 = Reader.GetDouble(0);
                套管N80料本期外购量 = Reader.GetDouble(1);
                套管N80料本期消耗量 = Reader.GetDouble(2);
                套管N80料期末库存 = Reader.GetDouble(3);
                套管N80料本年外购量 = Reader.GetDouble(5);
                套管N80料本年消耗量 = Reader.GetDouble(6);
            }
            Reader.Close();
            套管料期初库存 = 套管料期初库存 + 套管N80料期初库存;
            套管料本期外购量 = 套管料本期外购量 + 套管N80料本期外购量;
            套管料本期消耗量 = 套管料本期消耗量 + 套管N80料本期消耗量;
            套管料本年外购量 = 套管料本年外购量 + 套管N80料本年外购量;
            套管料本年消耗量 = 套管料本年消耗量 + 套管N80料本年消耗量;
            //油管接箍料
            string sql2 = @"            
            select dbo.原料期初库存(@年度,@月份,3) as 期初库存,dbo.原料本期收入(@年度,@月份,3) as 本期收入,dbo.原料本期发出(@年度,@月份,3) as 本期发出,dbo.原料期末库存(@年度,@月份,3) as 期末库存,dbo.原料未入库(@年度,@月份,3) as 未入库,[dbo].[原料本年累计收入](@年度,@月份,3),[dbo].[原料本年累计发出](@年度,@月份,3)";
            sql2 = sql2.Replace("@年度", year.ToString());
            sql2 = sql2.Replace("@月份", this.Month0.Text.ToString());
            Cmd.CommandText = sql2;
            Reader = Cmd.ExecuteReader();
            if (Reader.Read())
            {
                油管接篐料期初库存 = Reader.GetDouble(0);
                油管接篐料本期外购量 = Reader.GetDouble(1);
                油管接篐料本期消耗量 = Reader.GetDouble(2);
                油管接篐料期末库存 = Reader.GetDouble(3);
                油管接篐料本年外购量 = Reader.GetDouble(5);
                油管接篐料本年消耗量 = Reader.GetDouble(6);
            }
            Reader.Close();
            //套管接箍料
            string sql3 = @"            
                select dbo.原料期初库存(@年度,@月份,4) as 期初库存,dbo.原料本期收入(@年度,@月份,4) as 本期收入,dbo.原料本期发出(@年度,@月份,4) as 本期发出,dbo.原料期末库存(@年度,@月份,4) as 期末库存,dbo.原料未入库(@年度,@月份,4) as 未入库,[dbo].[原料本年累计收入](@年度,@月份,4),[dbo].[原料本年累计发出](@年度,@月份,4)";
            sql3 = sql3.Replace("@年度", year.ToString());
            sql3 = sql3.Replace("@月份", this.Month0.Text.ToString());
            Cmd.CommandText = sql3;
            Reader = Cmd.ExecuteReader();
            if (Reader.Read())
            {
                套管接篐料期初库存 = Reader.GetDouble(0);
                套管接篐料本期外购量 = Reader.GetDouble(1);
                套管接篐料本期消耗量 = Reader.GetDouble(2);
                套管接篐料期末库存 = Reader.GetDouble(3);
                套管接篐料本年外购量 = Reader.GetDouble(5);
                套管接篐料本年消耗量 = Reader.GetDouble(6);           
            }
            Reader.Close();
            //套管接箍料
            string sql4 = @"            
                select dbo.原料期初库存(@年度,@月份,104) as 期初库存,dbo.原料本期收入(@年度,@月份,104) as 本期收入,dbo.原料本期发出(@年度,@月份,104) as 本期发出,dbo.原料期末库存(@年度,@月份,104) as 期末库存,dbo.原料未入库(@年度,@月份,104) as 未入库,[dbo].[原料本年累计收入](@年度,@月份,104),[dbo].[原料本年累计发出](@年度,@月份,104)";
            sql4 = sql4.Replace("@年度", year.ToString());
            sql4 = sql4.Replace("@月份", this.Month0.Text.ToString());
            Cmd.CommandText = sql4;
            Reader = Cmd.ExecuteReader();
            if (Reader.Read())
            {
                套管N80接篐料期初库存 = Reader.GetDouble(0);
                套管N80接篐料本期外购量 = Reader.GetDouble(1);
                套管N80接篐料本期消耗量 = Reader.GetDouble(2);
                套管N80接篐料期末库存 = Reader.GetDouble(3);
                套管N80接篐料本年外购量 = Reader.GetDouble(5);
                套管N80接篐料本年消耗量 = Reader.GetDouble(6);         
            }
            Reader.Close();
            套管接篐料期初库存 = 套管接篐料期初库存 + 套管N80接篐料期初库存;
            套管接篐料本期外购量 = 套管接篐料本期外购量 + 套管N80接篐料本期外购量;       
            套管接篐料本年外购量 = 套管接篐料本年外购量 + 套管N80接篐料本年外购量;           
        }
        catch (Exception ex)
        {
            Conn.Close();
            return;
            throw ex;
        }
        finally
        {
            Conn.Close();
            Conn.Dispose();
        }
    }

    protected void Year0_SelectedIndexChanged(object sender, EventArgs e)
    {

    }

    protected void Month0_SelectedIndexChanged(object sender, EventArgs e)
    {

    }    
</script>
     <script type="text/javascript" language="javascript" src="/common.js"></script>
    <form id="form1" runat="server">
    <asp:Panel ID="Panel3" runat="server" CssClass="panel">
     年份：<asp:DropDownList ID="Year0" runat="server" AutoPostBack="true" 
            onselectedindexchanged="Year0_SelectedIndexChanged">
            <asp:ListItem>2009</asp:ListItem>
            <asp:ListItem>2010</asp:ListItem>
            <asp:ListItem>2011</asp:ListItem>
            <asp:ListItem>2012</asp:ListItem>
            <asp:ListItem>2013</asp:ListItem>
            <asp:ListItem>2014</asp:ListItem>
            <asp:ListItem>2015</asp:ListItem>           
            </asp:DropDownList>
     <span lang="zh-cn">&nbsp;&nbsp;&nbsp; 月份：</span><asp:DropDownList ID="Month0" runat="server" 
                AutoPostBack="true" 
            onselectedindexchanged="Month0_SelectedIndexChanged">
                <asp:ListItem Value=1>1</asp:ListItem>
                <asp:ListItem Value=2>2</asp:ListItem>
                <asp:ListItem Value=3>3</asp:ListItem>
                <asp:ListItem Value=4>4</asp:ListItem>
                <asp:ListItem Value=5>5</asp:ListItem>
                <asp:ListItem Value=6>6</asp:ListItem>
                <asp:ListItem Value=7>7</asp:ListItem>
                <asp:ListItem Value=8>8</asp:ListItem>
                <asp:ListItem Value=9>9</asp:ListItem>
                <asp:ListItem Value=10>10</asp:ListItem>
                <asp:ListItem Value=11>11</asp:ListItem>
                <asp:ListItem Value=12>12</asp:ListItem>
            </asp:DropDownList>          
            月&nbsp;&nbsp;&nbsp;
     <asp:Button ID="Button_Query"
            runat="server" Text="查看报表" CssClass="button" UseSubmitBehavior="true" onclick="Button_Query_Click"  Visible="false"
             />
            <asp:Button ID="Button_Save" runat="server" Text="导出报表" CssClass="button" 
                UseSubmitBehavior="False" onclick="Button_Save_Click"/>
    </asp:Panel>
    <asp:Panel ID="Panel2" runat="server" CssClass="panel2">
        <asp:Label ID="Message" runat="server" Text="·准备就绪" CssClass="prompt"></asp:Label>
    </asp:Panel>
    <div align="center">
  <style>
<!--table
	{mso-displayed-decimal-separator:"\.";
	mso-displayed-thousand-separator:"\,";}
@page
	{margin:.37in .55in .59in .64in;
	mso-header-margin:.31in;
	mso-footer-margin:.51in;
	mso-page-orientation:landscape;
	mso-horizontal-page-align:center;
	mso-vertical-page-align:center;}
tr
	{mso-height-source:auto;
	mso-ruby-visibility:none;}
col
	{mso-width-source:auto;
	mso-ruby-visibility:none;}
br
	{mso-data-placement:same-cell;}
.style0
	{mso-number-format:General;
	text-align:general;
	vertical-align:bottom;
	white-space:nowrap;
	mso-rotate:0;
	mso-background-source:auto;
	mso-pattern:auto;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial, sans-serif;
	mso-font-charset:0;
	border:none;
	mso-protection:locked visible;
	mso-style-name:"";}
.style0
	{mso-number-format:General;
	text-align:general;
	vertical-align:bottom;
	white-space:nowrap;
	mso-rotate:0;
	mso-background-source:auto;
	mso-pattern:auto;
	color:windowtext;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Arial, sans-serif;
	mso-font-charset:0;
	border:none;
	mso-protection:locked visible;
	mso-style-name:常规;
	mso-style-id:0;}
td
	{mso-style-parent:style0;
	padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	border:none;
	mso-background-source:auto;
	mso-pattern:auto;
	mso-protection:locked visible;
	white-space:nowrap;
	mso-rotate:0;}
.xl28
	{mso-style-parent:style0;
	font-size:10.0pt;
	font-family:Arial, sans-serif;
	mso-font-charset:0;
	vertical-align:bottom;
	mso-background-source:auto;
	mso-pattern:auto;}
.xl29
	{mso-style-parent:style17;
	font-size:10.0pt;
	text-align:center;
	border:.5pt solid windowtext;}
.xl30
	{mso-style-parent:style17;
	font-size:10.0pt;
	mso-number-format:"0\.00_ ";
	text-align:right;
	border:.5pt solid windowtext;}
.xl31
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:center;
	mso-background-source:auto;
	mso-pattern:auto;}
.xl32
	{mso-style-parent:style17;
	color:red;
	font-size:10.0pt;
	mso-number-format:"0\.00_ ";
	text-align:right;
	border:.5pt solid windowtext;}
.xl33
	{mso-style-parent:style17;
	font-size:10.0pt;
	text-align:left;
	border:.5pt solid windowtext;}
.xl34
	{mso-style-parent:style17;
	font-size:10.0pt;
	text-align:right;
	border:.5pt solid windowtext;}
.xl35
	{mso-style-parent:style17;
	color:red;
	font-size:10.0pt;
	text-align:right;
	border:.5pt solid windowtext;}
.xl36
	{mso-style-parent:style17;
	font-size:10.0pt;
	border:.5pt solid windowtext;}
.xl37
	{mso-style-parent:style17;
	font-size:10.0pt;
	mso-number-format:"0_ ";
	text-align:right;
	border:.5pt solid windowtext;}
.xl38
	{mso-style-parent:style17;
	color:maroon;
	font-size:10.0pt;
	text-align:right;
	border:.5pt solid windowtext;}
.xl39
	{mso-style-parent:style17;
	font-size:10.0pt;
	mso-number-format:"0\.000_ ";
	text-align:right;
	border:.5pt solid windowtext;}
.xl40
	{mso-style-parent:style17;
	color:black;
	font-size:10.0pt;
	mso-number-format:"0\.000_ ";
	text-align:right;
	border:.5pt solid windowtext;}
.xl41
	{mso-style-parent:style17;
	font-size:10.0pt;
	text-align:left;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;}
.xl42
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:center;}
.xl43
	{mso-style-parent:style0;
	font-size:10.0pt;
	mso-background-source:auto;
	mso-pattern:auto;}
.xl44
	{mso-style-parent:style0;
	font-size:10.0pt;
	font-family:Arial, sans-serif;
	mso-font-charset:0;
	text-align:center;
	mso-background-source:auto;
	mso-pattern:auto;}
.xl45
	{mso-style-parent:style0;
	font-size:11.0pt;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:none;
	border-left:none;}
.xl46
	{mso-style-parent:style0;
	font-size:10.0pt;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:none;
	border-left:none;
	mso-background-source:auto;
	mso-pattern:auto;}
.xl47
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:none;
	border-left:none;
	mso-background-source:auto;
	mso-pattern:auto;}
.xl48
	{mso-style-parent:style17;
	font-size:10.0pt;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:none;
	border-left:.5pt solid windowtext;}
.xl49
	{mso-style-parent:style17;
	font-size:10.0pt;
	text-align:center;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:none;
	border-left:.5pt solid windowtext;}
.xl50
	{mso-style-parent:style17;
	font-size:10.0pt;
	text-align:center;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;}
.xl51
	{mso-style-parent:style17;
	font-size:10.0pt;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:none;
	border-left:.5pt solid windowtext;}
.xl52
	{mso-style-parent:style17;
	font-size:10.0pt;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:none;
	border-left:none;}
.xl53
	{mso-style-parent:style17;
	font-size:10.0pt;
	text-align:center;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;}
.xl54
	{mso-style-parent:style17;
	font-size:10.0pt;
	text-align:center;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;}
.xl55
	{mso-style-parent:style17;
	font-size:20.0pt;
	font-weight:700;
	text-align:center;}
.xl56
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:center;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	mso-background-source:auto;
	mso-pattern:auto;}
.xl57
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:right;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	mso-background-source:auto;
	mso-pattern:auto;}
.xl58
	{mso-style-parent:style17;
	font-size:10.0pt;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;}
.xl59
	{mso-style-parent:style17;
	font-size:10.0pt;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;}
.xl60
	{mso-style-parent:style17;
	font-size:10.0pt;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;}
.xl61
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:none;
	border-left:none;}
.xl62
	{mso-style-parent:style17;
	font-size:10.0pt;
	text-align:left;}
ruby
	{ruby-align:left;}
rt
	{color:windowtext;
	font-size:9.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-char-type:none;
	display:none;}
-->
</style>
<!--[if gte mso 9]><xml>
 <x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>原料收拨平衡表</x:Name>
    <x:WorksheetOptions>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>600</x:HorizontalResolution>
      <x:VerticalResolution>600</x:VerticalResolution>
     </x:Print>
     <x:Selected/>
     <x:Panes>
      <x:Pane>
       <x:Number>3</x:Number>
       <x:ActiveRow>16</x:ActiveRow>
       <x:ActiveCol>5</x:ActiveCol>
      </x:Pane>
     </x:Panes>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <x:WindowHeight>3510</x:WindowHeight>
  <x:WindowWidth>15480</x:WindowWidth>
  <x:WindowTopX>-15</x:WindowTopX>
  <x:WindowTopY>-15</x:WindowTopY>
  <x:ProtectStructure>False</x:ProtectStructure>
  <x:ProtectWindows>False</x:ProtectWindows>
 </x:ExcelWorkbook>
</xml><![endif]-->
</head>

<body link=blue vlink=purple class=xl28>

<table x:str border=0 cellpadding=0 cellspacing=0 width=1990 style='border-collapse:
 collapse;table-layout:fixed;width:1495pt'>
 <col class=xl31 width=148 style='mso-width-source:userset;mso-width-alt:4736;
 width:111pt'>
 <col class=xl28 width=53 style='mso-width-source:userset;mso-width-alt:1696;
 width:40pt'>
 <col class=xl28 width=77 span=7 style='mso-width-source:userset;mso-width-alt:
 2464;width:58pt'>
 <col class=xl28 width=71 style='mso-width-source:userset;mso-width-alt:2272;
 width:53pt'>
 <col class=xl28 width=70 style='mso-width-source:userset;mso-width-alt:2240;
 width:53pt'>
 <col class=xl28 width=101 style='mso-width-source:userset;mso-width-alt:3232;
 width:76pt'>
 <col class=xl28 width=72 span=14 style='width:54pt'>
 <tr height=52 style='mso-height-source:userset;height:39.0pt'>
  <td colspan=12 height=52 class=xl55 width=982 style='height:39.0pt;
  width:739pt'>原料收拨平衡表</td>
  <td class=xl28 width=72 style='width:54pt'>　</td>
  <td class=xl28 width=72 style='width:54pt'>　</td>
  <td class=xl28 width=72 style='width:54pt'>　</td>
  <td class=xl28 width=72 style='width:54pt'>　</td>
  <td class=xl28 width=72 style='width:54pt'>　</td>
  <td class=xl28 width=72 style='width:54pt'>　</td>
  <td class=xl28 width=72 style='width:54pt'>　</td>
  <td class=xl28 width=72 style='width:54pt'>　</td>
  <td class=xl28 width=72 style='width:54pt'>　</td>
  <td class=xl28 width=72 style='width:54pt'>　</td>
  <td class=xl28 width=72 style='width:54pt'>　</td>
  <td class=xl28 width=72 style='width:54pt'>　</td>
  <td class=xl28 width=72 style='width:54pt'>　</td>
  <td class=xl28 width=72 style='width:54pt'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td height=24 class=xl62 style='height:18.0pt'>填报单位：材料公司</td>
  <td class=xl41>　</td>
  <td class=xl28>　</td>
  <td colspan=6 class=xl56>2011年 3 月</td>
  <td class=xl28>　</td>
  <td colspan=2 class=xl57>陕油统 材料B－1504</td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td rowspan=3 height=72 class=xl48 style='border-bottom:.5pt solid black;
  height:54.0pt'>指标名称</td>
  <td rowspan=3 class=xl48 style='border-bottom:.5pt solid black;border-top:
  none'>单位</td>
  <td rowspan=3 class=xl48 style='border-bottom:.5pt solid black'>期初库存</td>
  <td colspan=2 rowspan=2 class=xl51 style='border-right:.5pt solid black;
  border-bottom:.5pt solid black'>外购量(生产量)</td>
  <td colspan=6 class=xl58 style='border-right:.5pt solid black;border-left:
  none'>消耗量（自用或损失）</td>
  <td rowspan=2 class=xl29 style='border-top:none'>期末库存</td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td colspan=2 height=24 class=xl58 style='border-right:.5pt solid black;
  height:18.0pt;border-left:none'>消耗合计</td>
  <td colspan=2 class=xl58 style='border-right:.5pt solid black;'>生产</td>
  <td colspan=2 class=xl58 style='border:.5pt solid;border-right:.5pt solid black;border-left:
  none'>其它</td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td height=24 class=xl29 style='height:18.0pt;border-top:none;border-left:
  none'>本月</td>
  <td class=xl29 style='border-top:none;border-left:none'>累计</td>
  <td class=xl29 style='border-top:none;border-left:none'>本月</td>
  <td class=xl29 style='border-top:none;border-left:none'>累计</td>
  <td class=xl29 style='border-top:none;border-left:none'>本月</td>
  <td class=xl29 style='border-top:none;border-left:none'>累计</td>
  <td class=xl29 style='border-top:none;border-left:none'>本月</td>
  <td class=xl29 style='border-top:none;border-left:none'>累计</td>
  <td class=xl36 style='border-top:none;border-left:none'>　</td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td height=24 class=xl33 style='height:18.0pt;border-top:none'>一、原料</td>
  <td class=xl29 style='border-top:none;border-left:none'>吨</td>
  <td class=xl34 style='border-top:none;border-left:none'><span
  style='mso-spacerun:yes'>&nbsp;</span></td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl38 style='border-top:none;border-left:none'><span
  style='mso-spacerun:yes'>&nbsp;</span></td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td height=24 class=xl33 style='height:18.0pt;border-top:none'>油管</td>
  <td class=xl29 style='border-top:none;border-left:none'>吨</td>
  <td class=xl34 style='border-top:none;border-left:none' ><%=油管料期初库存 %></td>
  <td class=xl34 style='border-top:none;border-left:none'
   ><%=油管料本期外购量 %></td>
  <td class=xl39 style='border-top:none;border-left:none' ><%=油管料本年外购量%></td>
  <td class=xl39 style='border-top:none;border-left:none' ><%=油管料本期消耗量%></td>
  <td class=xl34 style='border-top:none;border-left:none' ><%=油管料本年消耗量%></td>
  <td class=xl39 style='border-top:none;border-left:none'
  x:fmla="=F7"><%=油管料本期消耗量%> </td>
  <td class=xl34 style='border-top:none;border-left:none' 
  x:fmla="=G7"><%=油管料本年消耗量%></td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl38 style='border-top:none;border-left:none'
  x:fmla="=C7+D7-F7"><%=油管料期初库存 + 油管料本期外购量 - 油管料本期消耗量%></td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td height=24 class=xl33 style='height:18.0pt;border-top:none'>套管</td>
  <td class=xl29 style='border-top:none;border-left:none'>吨</td>
  <td class=xl34 style='border-top:none;border-left:none' x:num="12815.627"><%=套管料期初库存%></td>
  <td class=xl34 style='border-top:none;border-left:none'
  ><%=套管料本期外购量%></td>
  <td class=xl39 style='border-top:none;border-left:none' ><%=套管料本年外购量 %></td>
  <td class=xl34 style='border-top:none;border-left:none' ><%=套管料本期消耗量 %></td>
  <td class=xl34 style='border-top:none;border-left:none'><%=套管料本年消耗量%> </td>
  <td class=xl34 style='border-top:none;border-left:none'
   x:fmla="=F8"><%=套管料本期消耗量%></td>
  <td class=xl34 style='border-top:none;border-left:none' x:num="11932.785"
  x:fmla="=G8"><%=套管料本年消耗量%> </td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl38 style='border-top:none;border-left:none'
   x:fmla="=C8+D8-F8"><%=套管料期初库存 + 套管料本期外购量 - 套管料本期消耗量%></td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td height=24 class=xl33 style='height:18.0pt;border-top:none'>油管接箍</td>
  <td class=xl29 style='border-top:none;border-left:none'>吨</td>
  <td class=xl34 style='border-top:none;border-left:none'><%=油管接篐料期初库存%></td>
  <td class=xl34 style='border-top:none;border-left:none' ><%=油管接篐料本期外购量 %></td>
  <td class=xl34 style='border-top:none;border-left:none'
  ><%=油管接篐料本年外购量%></td>
  <td class=xl34 style='border-top:none;border-left:none' ><%=油管接篐料本期消耗量%></td>
  <td class=xl39 style='border-top:none;border-left:none' ><%=油管接篐料本年消耗量%>
  </td>
  <td class=xl34 style='border-top:none;border-left:none' 
  x:fmla="=F9"><%=油管接篐料本期消耗量%></td>
  <td class=xl39 style='border-top:none;border-left:none'
  x:fmla="=G9"><%=油管接篐料本年消耗量%></td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl38 style='border-top:none;border-left:none' 
  x:fmla="=C9+D9-F9"><%=油管接篐料期初库存 + 油管接篐料本期外购量 - 油管接篐料本期消耗量%></td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td height=24 class=xl33 style='height:18.0pt;border-top:none'>套管接箍</td>
  <td class=xl29 style='border-top:none;border-left:none'>吨</td>
  <td class=xl40 style='border-top:none;border-left:none'><%=套管接篐料期初库存%>
  </td>
  <td class=xl35 style='border-top:none;border-left:none' ><%=套管接篐料本期外购量%></td>
  <td class=xl35 style='border-top:none;border-left:none'
  ><%=套管接篐料本年外购量%></td>
  <td class=xl35 style='border-top:none;border-left:none'
  ><%=套管接篐料本期消耗量%></td>
  <td class=xl34 style='border-top:none;border-left:none' x:num="623.726"><%=套管接篐料本年消耗量%></td>
  <td class=xl34 style='border-top:none;border-left:none'
  x:fmla="=F10"><%=套管接篐料本期消耗量%></td>
  <td class=xl34 style='border-top:none;border-left:none' x:num="623.726"
  x:fmla="=G10"><%=套管接篐料本年消耗量%></td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl38 style='border-top:none;border-left:none'
   x:fmla="=C10+D10-F10"><%=套管接篐料期初库存 + 套管接篐料本期外购量 - 套管接篐料本期消耗量%></td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td height=24 class=xl29 style='height:18.0pt;border-top:none'>　</td>
  <td class=xl29 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'><span
  style='mso-spacerun:yes'>&nbsp;</span></td>
  <td class=xl34 style='border-top:none;border-left:none'><span
  style='mso-spacerun:yes'>&nbsp;</span></td>
  <td class=xl34 style='border-top:none;border-left:none'><span
  style='mso-spacerun:yes'>&nbsp;</span></td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td height=24 class=xl33 style='height:18.0pt;border-top:none'>　</td>
  <td class=xl29 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl37 style='border-top:none;border-left:none'>　</td>
  <td class=xl37 style='border-top:none;border-left:none'>　</td>
  <td class=xl37 style='border-top:none;border-left:none'>　</td>
  <td class=xl37 style='border-top:none;border-left:none'>　</td>
  <td class=xl37 style='border-top:none;border-left:none'>　</td>
  <td class=xl37 style='border-top:none;border-left:none'>　</td>
  <td class=xl37 style='border-top:none;border-left:none'>　</td>
  <td class=xl37 style='border-top:none;border-left:none'>　</td>
  <td class=xl37 style='border-top:none;border-left:none'>　</td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td height=24 class=xl33 style='height:18.0pt;border-top:none'>　</td>
  <td class=xl29 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl32 style='border-top:none;border-left:none'>　</td>
  <td class=xl32 style='border-top:none;border-left:none'>　</td>
  <td class=xl32 style='border-top:none;border-left:none'>　</td>
  <td class=xl32 style='border-top:none;border-left:none'>　</td>
  <td class=xl32 style='border-top:none;border-left:none'>　</td>
  <td class=xl32 style='border-top:none;border-left:none'>　</td>
  <td class=xl32 style='border-top:none;border-left:none'>　</td>
  <td class=xl32 style='border-top:none;border-left:none'>　</td>
  <td class=xl32 style='border-top:none;border-left:none'>　</td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td height=24 class=xl33 style='height:18.0pt;border-top:none'>　</td>
  <td class=xl29 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td height=24 class=xl33 style='height:18.0pt;border-top:none'>　</td>
  <td class=xl29 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td height=24 class=xl33 style='height:18.0pt;border-top:none'>　</td>
  <td class=xl29 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td class=xl35 style='border-top:none;border-left:none'>　</td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td height=24 class=xl33 style='height:18.0pt;border-top:none'>　</td>
  <td class=xl29 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td height=24 class=xl33 style='height:18.0pt;border-top:none'>　</td>
  <td class=xl29 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td height=24 class=xl33 style='height:18.0pt;border-top:none'>　</td>
  <td class=xl29 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td height=24 class=xl33 style='height:18.0pt;border-top:none'>　</td>
  <td class=xl29 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td height=24 class=xl33 style='height:18.0pt;border-top:none'>　</td>
  <td class=xl29 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td height=24 class=xl33 style='height:18.0pt;border-top:none'>　</td>
  <td class=xl29 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td height=24 class=xl33 style='height:18.0pt;border-top:none'>　</td>
  <td class=xl29 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=24 style='mso-height-source:userset;height:18.0pt'>
  <td height=24 class=xl33 style='height:18.0pt;border-top:none'>　</td>
  <td class=xl29 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td class=xl34 style='border-top:none;border-left:none'>　</td>
  <td colspan=14 class=xl28 style='mso-ignore:colspan'>　</td>
 </tr>
 <tr height=22 style='mso-height-source:userset;height:16.5pt'>
  <td height=22 class=xl62 style='height:16.5pt'>主管领导：焦平</td>
  <td class=xl42></td>
  <td class=xl31>　</td>
  <td colspan=2 class=xl47>统计负责人：廉宝仁</td>
  <td class=xl46 style='border-top:none'>　</td>
  <td colspan=2 class=xl47>填报人：谷立凤</td>
  <td class=xl45 style='border-top:none'>　</td>
  <td colspan=3 class=xl61>报出日期：2011-4-12</td>
  <td colspan=3 class=xl43 style='mso-ignore:colspan'>　</td>
  <td colspan=11 class=xl44 style='mso-ignore:colspan'>　</td>
 </tr>
 <![if supportMisalignedColumns]>
 <tr height=0 style='display:none'>
  <td width=148 style='width:111pt'></td>
  <td width=53 style='width:40pt'></td>
  <td width=77 style='width:58pt'></td>
  <td width=77 style='width:58pt'></td>
  <td width=77 style='width:58pt'></td>
  <td width=77 style='width:58pt'></td>
  <td width=77 style='width:58pt'></td>
  <td width=77 style='width:58pt'></td>
  <td width=77 style='width:58pt'></td>
  <td width=71 style='width:53pt'></td>
  <td width=70 style='width:53pt'></td>
  <td width=101 style='width:76pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
 </tr>
 <![endif]>
</table>
    </div>
    </form>
    
<script type="text/javascript">
       parent.hidesubmenu(true);
</script>
</body>
</html>
